import random as rd
import pandas as pd
import datetime

rd.seed(datetime.datetime.now().microsecond)
list1 = sorted([rd.randint(1, 10) for i in range(10)])[1:-1]
val = round(sum(list1) / len(list1), 2)

df = pd.read_excel("csen.xlsx", engine='openpyxl')
dict1 = df.set_index('选手ID').to_dict('index')
for i in dict1:
    print(round(dict1[i]['难度系数'] * val, 2))
